﻿
-- ================================================
-- Remarks: 
-- ================================================

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


/****Create Default Records ****/
PRINT 'INSERTING DEFAULT DATA .... [Ivy_Sys_RoleMaster]'
GO

		--Ivy_RoleMaster_Insert 'SYSSPRADM','System Super Admin', 'Super Administrator for the Portal','1',0,-1,NULL,'Default'
		--GO
		--Ivy_RoleMaster_Insert 'SYSADMIN','System Admin', 'Administrator for the Portal','1',0,-1,NULL,'Default'
		--GO
		--Ivy_RoleMaster_Insert 'SYSOPRAT','System Operator', 'Operator for the Portal','1',0,-1,NULL,'Default'
		--GO
		--Ivy_RoleMaster_Insert 'SCTSUPADM','Society Super Admin', 'Super Administrator for the Society related operations','1',0,-1,NULL,'Default'
		--GO
		--Ivy_RoleMaster_Insert 'SCTADMIN','Society Admin', 'Administrator for the Society, a member of Management Committee','1',0,-1,NULL,'Default'
		--GO
		--Ivy_RoleMaster_Insert 'SCTOPRAT','Society Operator', 'Operator for the Society, mostly employees of the society','1',0,-1,NULL,'Default'
		--GO
		--Ivy_RoleMaster_Insert 'APTBLDR','Apartment Builder', 'Builder of the Apartment complex','1',0,-1,NULL,'Default'
		--GO
		--Ivy_RoleMaster_Insert 'FLTOWNER','Flat Owner', 'Flat owner','1',0,-1,NULL,'Default'
		--GO
		--Ivy_RoleMaster_Insert 'FLTRESI','Resident', 'Resident of a Flat','1',0,-1,NULL,'Default'
		--GO

		SET IDENTITY_INSERT [Sys_RoleMaster] ON
		INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (1, N'SYSSPRADM', N'System Super Admin', N'Super Administrator for the Portal', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
		INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (2, N'SYSADMIN', N'System Admin', N'Administrator for the Portal', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
		INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (3, N'SYSOPRAT', N'System Operator', N'Operator for the Portal', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
		INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (4, N'SCTSUPADM', N'Society Super Admin', N'Super Administrator for the Society related operations', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
		INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (5, N'SCTADMIN', N'Society Admin', N'Administrator for the Society, a member of Management Committee', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
		INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (6, N'SCTOPRAT', N'Society Operator', N'Operator for the Society, mostly employees of the society', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
		INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (7, N'APTBLDR', N'Apartment Builder', N'Builder of the Apartment complex', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
		INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (8, N'FLTOWNER', N'Flat Owner', N'Flat owner', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
		INSERT [Sys_RoleMaster] ([RoleKey], [RoleCode], [RoleName], [RoleDescription], [Sys_DateOfCreation], [Sys_DateOfModification], [Sys_CreatedByID], [Sys_ModifiedByID], [Sys_DeleteType], [Sys_IsDeleted], [Sys_OrganizationID], [Sys_InitialPrimaryKeys], [Sys_WorkstationName]) VALUES (9, N'FLTRESI', N'Resident', N'Resident of a Flat', GETDATE(), GETDATE(), N'-1', N'-1', 0, 0, -1, NULL, (SELECT @@SERVERNAME))
		SET IDENTITY_INSERT [Sys_RoleMaster] OFF